-- 1.
 select employee_id, prior employee_id, 
        lpad(' ', level * 3) || 
        first_name || ' ' || 
        last_name as fullname, 
        title 
   from employee
  start with employee_id = 1
connect by manager_id = prior employee_id

-- 2.
 select employee_id, prior employee_id, 
        lpad(' ', level * 3) || first_name || ' ' || last_name as fullname, title 
   from employee
  start with employee_id = 9
connect by prior manager_id = employee_id

-- 3.
 select employee_id, prior employee_id, level,
        lpad(' ', level * 3) || first_name || ' ' || last_name as fullname, title 
   from employee
  where level = 5
connect by prior employee_id = manager_id
  start with employee_id = 1
  
  SELECT id_gen.NEXTVAL, dbms_crypto.randombytes(15), dbms_crypto.randombytes(150)
FROM dual
CONNECT BY LEVEL <= 1000;